const Goods=require('../model/goods.model')

class GoodsService{
    async createGoods(goods){
        const res=await Goods.create(goods)     //写入数据库
        return res.dataValues
    }

    async updateGoods(id,goods){
        const res=await Goods.update(goods,{where:{id}})

        return res[0]>0?true:false
    }
    async removeGoods(id) {
        const res = await Goods.destroy({ where: { id } })
    
        return res > 0 ? true : false
    }
    async restoreGoods(id) {
        const res = await Goods.restore({ where: { id } })
    
        return res > 0 ? true : false
    }
    async findGoods(pageNum, pageSize) {
        // // 1. 获取总数
        // const count = await Goods.count()
        // // console.log(count)
        // // 2. 获取分页的具体数据
        // const offset = (pageNum - 1) * pageSize
        // const rows = await Goods.findAll({ offset: offset, limit: pageSize * 1 })
    
        const offset = (pageNum - 1) * pageSize
        const { count, rows } = await Goods.findAndCountAll({
          offset: offset,   //偏移量
          limit: pageSize * 1,  //每页显示多少条(需要转为数值型)
        })
        return {
          pageNum,
          pageSize,
          total: count,
          list: rows,
        }
      }
}

module.exports=new GoodsService()